UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7Ik5aO/t6oAPWpBaQgt5ci8Yn0yM9rI+vjBrUf/z3NY=' 
WHERE 
  key_id = '5f943ab4bd9a3f394588c18bd835c049cd53b0c87a8e681a89d9bfebb0151b5f' 
  AND (
    token = '7Ik5aO/t6oAPWpBaQgt5ci8Yn0yM9rI+vjBrUf/z3NY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030