UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gXE9dNjxhUft8CtkKD57IoQbEYbcILFU4rgwbs3ecaA='
WHERE
key_id = '997fcb9182d06f3ca93e3038189cdab7b8c0fb24a2b29ab04666e79e7dc81d21'
AND (
token = 'gXE9dNjxhUft8CtkKD57IoQbEYbcILFU4rgwbs3ecaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)