UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U+JL9w80vsgnYHhggWfALFcLoMdFJEBdSlBtwsmBxmg='
WHERE
key_id = 'f3dd87f168df22ef702816474ece6017ccc197e829ac2069d9e0e4c13a87e77e'
AND (
token = 'U+JL9w80vsgnYHhggWfALFcLoMdFJEBdSlBtwsmBxmg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)