UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cm6jzpaMz35a0iSIqQBL+cnFojWeCKZqFieRf6YbYEQ='
WHERE
key_id = 'e9c7a5d4996086926afefa0dd627589f18f02c9a4ff007494532e01f94bae52a'
AND (
token = 'cm6jzpaMz35a0iSIqQBL+cnFojWeCKZqFieRf6YbYEQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)