UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5zPn9S/MKsg8t4QbxhStixMtACEKI3bZQEmsAg79CFA=' 
WHERE 
  key_id = '0f2136becd6b6d1e42d10d48a7312cf5aa0cb0e04be48a0693d5a6b4d89235a8' 
  AND (
    token = '5zPn9S/MKsg8t4QbxhStixMtACEKI3bZQEmsAg79CFA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034