UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n6yjLv8solgpF/9UmWKi4FyCYQWI2rCu/jC/J61s4JA='
WHERE
key_id = 'e786fcc7e406f9fb14ab9c2d29ca466ce40da5e7376898314c8bfbc9238f53c4'
AND (
token = 'n6yjLv8solgpF/9UmWKi4FyCYQWI2rCu/jC/J61s4JA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)