UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '357GT3AuS6ChtJwYUHd8IuHMreeyMakX6k8qAGcX6r4='
WHERE
key_id = 'ac0703855bfb32e91cc6c4a32c17f78a7f4b83825fdddf6f1c4f799cba63de04'
AND (
token = '357GT3AuS6ChtJwYUHd8IuHMreeyMakX6k8qAGcX6r4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)