UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jNVvxS3SiZZuR8ExOfKfnMMmxGL51Ry19yLKviTj6Mo='
WHERE
key_id = 'c0f71d15c6066a3c31d12619cf04ab924ef3e9114e7ae152663bf60f4636ad5c'
AND (
token = 'jNVvxS3SiZZuR8ExOfKfnMMmxGL51Ry19yLKviTj6Mo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)