UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cmR7jgPNEK6NzbTXO09qzNfvjwIhuynoMY60lbQvtcY='
WHERE
key_id = '08adc35ebcc83a2ebf0ae76268d5d7ffb073f8786df253f1a0614011e22f93ce'
AND (
token = 'cmR7jgPNEK6NzbTXO09qzNfvjwIhuynoMY60lbQvtcY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)