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