UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2MNwYG6KC2SYoW1Le9vyrQ8so5XgLPLmQi3U+v0XiN4=' 
WHERE 
  key_id = '5fed0cdce9669e123a8da45663c2cd8b6862080e6056a3b1d25e6b37d0adddb2' 
  AND (
    token = '2MNwYG6KC2SYoW1Le9vyrQ8so5XgLPLmQi3U+v0XiN4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00061