UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9hl9CB2/mkXh0FH+YFe0AyQLLTSSbN2tLsLI4q0Xt70='
WHERE
key_id = 'afcb40e0c60221df5d450df523425846842d9eb02c6bfb11e64f012cd2294da2'
AND (
token = '9hl9CB2/mkXh0FH+YFe0AyQLLTSSbN2tLsLI4q0Xt70='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)