UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8SM7ZmkwSBZI6DGgVxHhIpgMmV77Qavr+PFjeSPOVUs='
WHERE
key_id = 'c8f4c4b7e9c5159625f769d651b56e1cdeafef94693aadb8ccdb903c97f0a903'
AND (
token = '8SM7ZmkwSBZI6DGgVxHhIpgMmV77Qavr+PFjeSPOVUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)