UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm0bGl/kULJdJsKVXU6apYZSQqvVoirMsgR6pYiN65M4='
WHERE
key_id = '0c218cc283c7e2cb7f4c16c6f3fe9f651876a39ed4d8e443312fd41fbd857ec2'
AND (
token = 'm0bGl/kULJdJsKVXU6apYZSQqvVoirMsgR6pYiN65M4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)