UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fJzNIUJyGfJCVtHkTds9+v9TpbkfgBVPWnAewD5YzZ4='
WHERE
key_id = 'b30bca2a49a448650b74cbd7e618f69c64c7f93c7b96aa3872880e3ad87bc513'
AND (
token = 'fJzNIUJyGfJCVtHkTds9+v9TpbkfgBVPWnAewD5YzZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)