UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x+1l5MmRhBYGo+hFdKWHIE0Wczw5mH8PwbTyjNpp/LQ='
WHERE
key_id = 'ca1b9e69692953bd5f5e6177550735b8b681ae39b5e1fc66379aa25e17147c06'
AND (
token = 'x+1l5MmRhBYGo+hFdKWHIE0Wczw5mH8PwbTyjNpp/LQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)