UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AY0qSv8+b90bfWUHKI9s01sRN9K3klvm1Q9Jeg3m/z4='
WHERE
key_id = 'fe1dbb72127698f197a4ae30931fb3b511a0459a8aaa5106692629cde986f88d'
AND (
token = 'AY0qSv8+b90bfWUHKI9s01sRN9K3klvm1Q9Jeg3m/z4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)