UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HvruZJ8C1foegDlX/cH6/J4gc4tMCRXR/kk8Sr3PiL0='
WHERE
key_id = 'c8c8b59748bbddbfc245ff0b4b56e47622cdde33a5b3c37048757379fc735c39'
AND (
token = 'HvruZJ8C1foegDlX/cH6/J4gc4tMCRXR/kk8Sr3PiL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)