UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'J/fe4U/M67t2FLVrEf5VHpwYXsD9iE3wB9jgnaMOfRA=' 
WHERE 
  key_id = 'f3b9782d0cf70f2a381d73887246d063dbca84b0b8e924755ef6780205a68456' 
  AND (
    token = 'J/fe4U/M67t2FLVrEf5VHpwYXsD9iE3wB9jgnaMOfRA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022