UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'M1zK+xSLvnD65+ZUyrMYRUaF30sSa7p6D0Uci0LV3ss=' 
WHERE 
  key_id = 'c5be9fff6154427dfef71a7f075eca5695fe2682dc315e9f1fd2f9e944ff9748' 
  AND (
    token = 'M1zK+xSLvnD65+ZUyrMYRUaF30sSa7p6D0Uci0LV3ss=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021