UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nAbDpa/qOWiKzfY0q5aeKxeTqJbAL2zWTbloRZsYZC0='
WHERE
key_id = '997817fe1f6066820c0de7e4b23ad98e315921a904cc0d6fe6e15a623f5daca4'
AND (
token = 'nAbDpa/qOWiKzfY0q5aeKxeTqJbAL2zWTbloRZsYZC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)