UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lPHqGV+ZR+xJIwNK+G1yEZrak+WaP+BDz5NGvJZOy04='
WHERE
key_id = '0607e67debaf67f88aa95408507575b5ae1bb69b600aa6a68f82faa93d7515ec'
AND (
token = 'lPHqGV+ZR+xJIwNK+G1yEZrak+WaP+BDz5NGvJZOy04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)