UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E3aGBJAZ3DlUXuEUOn89YWFjhF5A9XEGPcMlU1s2C6M='
WHERE
key_id = '7cae13ca5db5b80c39124651bb272470002f7fb82b32f505b0313e125919ca8f'
AND (
token = 'E3aGBJAZ3DlUXuEUOn89YWFjhF5A9XEGPcMlU1s2C6M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)