UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B11c6vf9tgG6286BgkaGa4ebEV8o3GPb9JJkTboiXJU='
WHERE
key_id = '830f8ff6dda8b8d0ab0f97d1c2f709f2ccb0a5cf3b8e0664e989ff04ec9ccf4b'
AND (
token = 'B11c6vf9tgG6286BgkaGa4ebEV8o3GPb9JJkTboiXJU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)