UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '389GexIIPNWHysdzpYFv0+GhH6th9xJuDp/pl1JhD+k=' 
WHERE 
  key_id = '99fc6c7e1bf1b928119fca85fe8ba3c885d08be6064905132609e39c3f3aacf6' 
  AND (
    token = '389GexIIPNWHysdzpYFv0+GhH6th9xJuDp/pl1JhD+k=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033