UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C2CNdHcbgxku6hiW0luxYOCRgGK18eWDHMdcEu5gqhw='
WHERE
key_id = 'c717356d207231b57da75f05cc191a1aa2e099b5502a6194e177724eafdbba9f'
AND (
token = 'C2CNdHcbgxku6hiW0luxYOCRgGK18eWDHMdcEu5gqhw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)