UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qsUzMFysVEsHdBL67bj8rrsCoP6WTOJRHpG6beDyMOE='
WHERE
key_id = '5561c1b77b83f8dfc2de42fe1ab35255af9ff566713fa265eae9a9fde9be7e27'
AND (
token = 'qsUzMFysVEsHdBL67bj8rrsCoP6WTOJRHpG6beDyMOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)