UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CqGNGY4/32cKFcEwi4O6QH0+NfTVRF0z0PExiiyx/to='
WHERE
key_id = 'e778b2ceb9f3db4079a6d7a7123a76851fbc82bcd3ddb388c0986f69a5d8c47e'
AND (
token = 'CqGNGY4/32cKFcEwi4O6QH0+NfTVRF0z0PExiiyx/to='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)