UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zoNXPC8mOj0JR4reO2qRlLOISCpRqoirtSer/duM+SQ='
WHERE
key_id = '04931e3c8cef4e41a8e5b13c6170d55e02292764078ff6bc588d2eabc73173dd'
AND (
token = 'zoNXPC8mOj0JR4reO2qRlLOISCpRqoirtSer/duM+SQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)