UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QRpzwqgaSkVk72VhpAJ9Ftg/K98+SUHU/FdK/bdI6QY='
WHERE
key_id = '2966c7a24e5dcbb9ccc644e21ef9d4524cf82a216f7b0f8f419aa5ef20aa20e0'
AND (
token = 'QRpzwqgaSkVk72VhpAJ9Ftg/K98+SUHU/FdK/bdI6QY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)