UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ez95UHa1RTA6SFZjvTC0cGoX5xns3HbBbtieH5nmti8='
WHERE
key_id = 'a93d1a2ba37ac526d6e8a806a945636249203a5b65b2e2b185c96f59674ef0e3'
AND (
token = 'ez95UHa1RTA6SFZjvTC0cGoX5xns3HbBbtieH5nmti8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)