UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XRWychxlWY1CEA8Ap7zxGAeLoNreISIDMvo6eY0FRkA=' 
WHERE 
  key_id = '97eaea7a10f9a2ed6906134dc948a0f5c8a0f42ce67a718464cd43b3de1c4035' 
  AND (
    token = 'XRWychxlWY1CEA8Ap7zxGAeLoNreISIDMvo6eY0FRkA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021