UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0vWxeaY2dDnzP4xWvISVa0WEKcSxZb7U/OdWxyM4ivw=' 
WHERE 
  key_id = '176025d281d4b809ff42a74638e7b5a85b1c786d513ab6abf2e5faba4703a02f' 
  AND (
    token = '0vWxeaY2dDnzP4xWvISVa0WEKcSxZb7U/OdWxyM4ivw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033